<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>DataExtractor: E:/cas/cas.0.7.0/sfw/src/MinConsole/MinConsole.0.8.0/MinConsole/Gaf/Utils/Log/Dumper.cs Source File</title>
<link href="../../tabs.css" rel="stylesheet" type="text/css"/>
<link href="../../doxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<!-- Generated by Doxygen 1.7.2 -->
<div class="navigation" id="top">
  <div class="tabs">
    <ul class="tablist">
      <li><a href="../../index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="../../namespaces.html"><span>Packages</span></a></li>
      <li><a href="../../annotated.html"><span>Classes</span></a></li>
      <li class="current"><a href="../../files.html"><span>Files</span></a></li>
    </ul>
  </div>
  <div class="tabs2">
    <ul class="tablist">
      <li><a href="../../files.html"><span>File&#160;List</span></a></li>
    </ul>
  </div>
<div class="header">
  <div class="headertitle">
<h1>E:/cas/cas.0.7.0/sfw/src/MinConsole/MinConsole.0.8.0/MinConsole/Gaf/Utils/Log/Dumper.cs</h1>  </div>
</div>
<div class="contents">
<a href="../../d6/db6/Dumper_8cs.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 ﻿using System;
<a name="l00002"></a>00002 <span class="keyword">using</span> System.Text.RegularExpressions;
<a name="l00003"></a>00003 <span class="keyword">using</span> System.Data;
<a name="l00004"></a>00004 <span class="keyword">using</span> System.Diagnostics;
<a name="l00005"></a>00005 <span class="keyword">using</span> System.Collections.Specialized;
<a name="l00006"></a>00006 <span class="keyword">using</span> System.Text;
<a name="l00007"></a>00007 
<a name="l00008"></a>00008 <span class="keyword">namespace </span>MinConsole.Gaf.Utils
<a name="l00009"></a>00009 {
<a name="l00010"></a>00010 
<a name="l00012"></a>00012     <span class="comment">// Dumper - provides methods API for returning nice looking ; ) dump strings of various types of types during run-time </span>
<a name="l00014"></a><a class="code" href="../../db/dac/classMinConsole_1_1Gaf_1_1Utils_1_1Dumper.html">00014</a> <span class="comment"></span>    <span class="keyword">public</span> <span class="keyword">class </span><a class="code" href="../../db/dac/classMinConsole_1_1Gaf_1_1Utils_1_1Dumper.html">Dumper</a>
<a name="l00015"></a>00015     {
<a name="l00016"></a>00016 
<a name="l00024"></a><a class="code" href="../../db/dac/classMinConsole_1_1Gaf_1_1Utils_1_1Dumper.html#a846227f626b01d87aeefb9f79964e79f">00024</a>         <span class="keyword">public</span> <span class="keyword">static</span> <span class="keywordtype">string</span> DumpDs(<span class="keywordtype">string</span> msg, ref System.Data.DataSet ds)
<a name="l00025"></a>00025         {
<a name="l00026"></a>00026 
<a name="l00027"></a>00027             StringBuilder objStringBuilder = <span class="keyword">new</span> StringBuilder();
<a name="l00028"></a>00028             <span class="keywordflow">if</span> (ds == null)
<a name="l00029"></a>00029             {
<a name="l00030"></a>00030                 objStringBuilder.AppendLine(<span class="stringliteral">&quot;Null dataset passed &quot;</span>);
<a name="l00031"></a>00031                 <span class="keywordflow">return</span> objStringBuilder.ToString();
<a name="l00032"></a>00032             }
<a name="l00033"></a>00033 
<a name="l00034"></a>00034             objStringBuilder.AppendLine(<span class="stringliteral">&quot;===================================================&quot;</span> + msg + <span class="stringliteral">&quot; START &quot;</span>);
<a name="l00035"></a>00035             <span class="keywordflow">if</span> (ds != null)
<a name="l00036"></a>00036             {
<a name="l00037"></a>00037                 <span class="keywordflow">if</span> (ds.Tables == null)
<a name="l00038"></a>00038                 {
<a name="l00039"></a>00039                     objStringBuilder.AppendLine(<span class="stringliteral">&quot;ds.Tables == null &quot;</span>);
<a name="l00040"></a>00040                     <span class="keywordflow">return</span> objStringBuilder.ToString();
<a name="l00041"></a>00041                 }
<a name="l00042"></a>00042 
<a name="l00043"></a>00043                 objStringBuilder.AppendLine(msg);
<a name="l00044"></a>00044                 <span class="keywordflow">foreach</span> (System.Data.DataTable dt in ds.Tables)
<a name="l00045"></a>00045                 {
<a name="l00046"></a>00046                     <span class="keywordflow">if</span> (dt == null)
<a name="l00047"></a>00047                     {
<a name="l00048"></a>00048                         objStringBuilder.AppendLine(<span class="stringliteral">&quot;ds.Tables == null &quot;</span>);
<a name="l00049"></a>00049                         <span class="keywordflow">continue</span>;
<a name="l00050"></a>00050                     }
<a name="l00051"></a>00051 
<a name="l00052"></a>00052                     objStringBuilder.AppendLine(<span class="stringliteral">&quot;================= My TableName is  &quot;</span> +
<a name="l00053"></a>00053                     dt.TableName + <span class="stringliteral">&quot; ========================= START&quot;</span>);
<a name="l00054"></a>00054                     <span class="keywordtype">int</span> colNumberInRow = 0;
<a name="l00055"></a>00055 
<a name="l00056"></a>00056                     <span class="keywordflow">foreach</span> (System.Data.DataColumn dc in dt.Columns)
<a name="l00057"></a>00057                     {
<a name="l00058"></a>00058                         <span class="keywordflow">if</span> (dc == null)
<a name="l00059"></a>00059                         {
<a name="l00060"></a>00060                             objStringBuilder.AppendLine(<span class="stringliteral">&quot;ds.Tables == null &quot;</span>);
<a name="l00061"></a>00061                             <span class="keywordflow">continue</span>;
<a name="l00062"></a>00062                         }
<a name="l00063"></a>00063 
<a name="l00064"></a>00064                         objStringBuilder.Append(<span class="stringliteral">&quot; | &quot;</span>);
<a name="l00065"></a>00065                         objStringBuilder.Append(<span class="stringliteral">&quot; |&quot;</span> + colNumberInRow + <span class="stringliteral">&quot;| &quot;</span>);
<a name="l00066"></a>00066                         objStringBuilder.Append(dc.ColumnName + <span class="stringliteral">&quot; | &quot;</span>);
<a name="l00067"></a>00067                         colNumberInRow++;
<a name="l00068"></a>00068                     } <span class="comment">//eof foreach (DataColumn dc in dt.Columns)</span>
<a name="l00069"></a>00069                     <span class="keywordtype">int</span> rowNum = 0;
<a name="l00070"></a>00070                     <span class="keywordflow">foreach</span> (System.Data.DataRow dr in dt.Rows)
<a name="l00071"></a>00071                     {
<a name="l00072"></a>00072                         objStringBuilder.Append(<span class="stringliteral">&quot;\n row &quot;</span> + rowNum + <span class="stringliteral">&quot; --- &quot;</span>);
<a name="l00073"></a>00073                         <span class="keywordtype">int</span> colNumber = 0;
<a name="l00074"></a>00074                         <span class="keywordflow">foreach</span> (System.Data.DataColumn dc in dt.Columns)
<a name="l00075"></a>00075                         {
<a name="l00076"></a>00076                             objStringBuilder.Append(<span class="stringliteral">&quot; |&quot;</span> + colNumber + <span class="stringliteral">&quot;| &quot;</span>);
<a name="l00077"></a>00077                             objStringBuilder.Append(dr[dc].ToString() + <span class="stringliteral">&quot; &quot;</span>);
<a name="l00078"></a>00078                             colNumber++;
<a name="l00079"></a>00079                         } <span class="comment">//eof foreach (DataColumn dc in dt.Columns)</span>
<a name="l00080"></a>00080                         rowNum++;
<a name="l00081"></a>00081                     }   <span class="comment">//eof foreach (DataRow dr in dt.Rows)</span>
<a name="l00082"></a>00082                     objStringBuilder.Append(<span class="stringliteral">&quot; \n&quot;</span>);
<a name="l00083"></a>00083                     objStringBuilder.AppendLine(<span class="stringliteral">&quot;================= Table &quot;</span> +
<a name="l00084"></a>00084     dt.TableName + <span class="stringliteral">&quot; ========================= END&quot;</span>);
<a name="l00085"></a>00085                     objStringBuilder.AppendLine(<span class="stringliteral">&quot;===================================================&quot;</span> + msg + <span class="stringliteral">&quot; END &quot;</span>);
<a name="l00086"></a>00086                 }       <span class="comment">//eof foreach (DataTable dt in ds.Tables)</span>
<a name="l00087"></a>00087             } <span class="comment">//eof if ds !=null </span>
<a name="l00088"></a>00088             <span class="keywordflow">else</span>
<a name="l00089"></a>00089             {
<a name="l00090"></a>00090                 objStringBuilder.AppendLine(<span class="stringliteral">&quot;NULL DataSet object passed for debugging !!!&quot;</span>);
<a name="l00091"></a>00091             }
<a name="l00092"></a>00092             <span class="keywordflow">return</span> objStringBuilder.ToString();
<a name="l00093"></a>00093         } <span class="comment">//eof method </span>
<a name="l00094"></a>00094 
<a name="l00102"></a><a class="code" href="../../db/dac/classMinConsole_1_1Gaf_1_1Utils_1_1Dumper.html#a92808beb2c60c0f9d2af20787c20448f">00102</a>         <span class="keyword">public</span> <span class="keyword">static</span> <span class="keywordtype">string</span> DumpDt(<span class="keywordtype">string</span> msg, ref System.Data.DataTable dt)
<a name="l00103"></a>00103         {
<a name="l00104"></a>00104 
<a name="l00105"></a>00105             StringBuilder objStringBuilder = <span class="keyword">new</span> StringBuilder();
<a name="l00106"></a>00106 
<a name="l00107"></a>00107             objStringBuilder.AppendLine(<span class="stringliteral">&quot;===================================================&quot;</span> + msg + <span class="stringliteral">&quot; START &quot;</span>);
<a name="l00108"></a>00108             <span class="keywordflow">if</span> (dt == null)
<a name="l00109"></a>00109             {
<a name="l00110"></a>00110                 objStringBuilder.AppendLine(<span class="stringliteral">&quot;ds.Tables == null &quot;</span>);
<a name="l00111"></a>00111 
<a name="l00112"></a>00112             }
<a name="l00113"></a>00113 
<a name="l00114"></a>00114             objStringBuilder.AppendLine(<span class="stringliteral">&quot;================= My TableName is  &quot;</span> +
<a name="l00115"></a>00115             dt.TableName + <span class="stringliteral">&quot; ========================= START&quot;</span>);
<a name="l00116"></a>00116             <span class="keywordtype">int</span> colNumberInRow = 0;
<a name="l00117"></a>00117 
<a name="l00118"></a>00118             <span class="keywordflow">foreach</span> (System.Data.DataColumn dc in dt.Columns)
<a name="l00119"></a>00119             {
<a name="l00120"></a>00120                 <span class="keywordflow">if</span> (dc == null)
<a name="l00121"></a>00121                 {
<a name="l00122"></a>00122                     objStringBuilder.AppendLine(<span class="stringliteral">&quot;ds.Tables == null &quot;</span>);
<a name="l00123"></a>00123                     <span class="keywordflow">continue</span>;
<a name="l00124"></a>00124                 }
<a name="l00125"></a>00125 
<a name="l00126"></a>00126                 objStringBuilder.Append(<span class="stringliteral">&quot; | &quot;</span>);
<a name="l00127"></a>00127                 objStringBuilder.Append(<span class="stringliteral">&quot; |&quot;</span> + colNumberInRow + <span class="stringliteral">&quot;| &quot;</span>);
<a name="l00128"></a>00128                 objStringBuilder.Append(dc.ColumnName + <span class="stringliteral">&quot; | &quot;</span>);
<a name="l00129"></a>00129                 colNumberInRow++;
<a name="l00130"></a>00130             } <span class="comment">//eof foreach (DataColumn dc in dt.Columns)</span>
<a name="l00131"></a>00131             <span class="keywordtype">int</span> rowNum = 0;
<a name="l00132"></a>00132             <span class="keywordflow">foreach</span> (System.Data.DataRow dr in dt.Rows)
<a name="l00133"></a>00133             {
<a name="l00134"></a>00134                 objStringBuilder.Append(<span class="stringliteral">&quot;\n row &quot;</span> + rowNum + <span class="stringliteral">&quot; --- &quot;</span>);
<a name="l00135"></a>00135                 <span class="keywordtype">int</span> colNumber = 0;
<a name="l00136"></a>00136                 <span class="keywordflow">foreach</span> (System.Data.DataColumn dc in dt.Columns)
<a name="l00137"></a>00137                 {
<a name="l00138"></a>00138                     objStringBuilder.Append(<span class="stringliteral">&quot; |&quot;</span> + colNumber + <span class="stringliteral">&quot;| &quot;</span>);
<a name="l00139"></a>00139                     objStringBuilder.Append(dr[dc].ToString() + <span class="stringliteral">&quot; &quot;</span>);
<a name="l00140"></a>00140                     colNumber++;
<a name="l00141"></a>00141                 } <span class="comment">//eof foreach (DataColumn dc in dt.Columns)</span>
<a name="l00142"></a>00142                 rowNum++;
<a name="l00143"></a>00143             }   <span class="comment">//eof foreach (DataRow dr in dt.Rows)</span>
<a name="l00144"></a>00144             objStringBuilder.Append(<span class="stringliteral">&quot; \n&quot;</span>);
<a name="l00145"></a>00145             objStringBuilder.AppendLine(<span class="stringliteral">&quot;================= Table &quot;</span> +
<a name="l00146"></a>00146 dt.TableName + <span class="stringliteral">&quot; ========================= END&quot;</span>);
<a name="l00147"></a>00147             objStringBuilder.AppendLine(<span class="stringliteral">&quot;===================================================&quot;</span> + msg + <span class="stringliteral">&quot; END &quot;</span>);
<a name="l00148"></a>00148 
<a name="l00149"></a>00149             <span class="keywordflow">return</span> objStringBuilder.ToString();
<a name="l00150"></a>00150         } <span class="comment">//eof method </span>
<a name="l00151"></a>00151 
<a name="l00158"></a><a class="code" href="../../db/dac/classMinConsole_1_1Gaf_1_1Utils_1_1Dumper.html#ad97d3a97e710ca5dba001674fb9d6575">00158</a>         <span class="keyword">public</span> <span class="keyword">static</span> <span class="keywordtype">string</span> DumpHtmlDs(<span class="keywordtype">string</span> msg, ref System.Data.DataSet ds)
<a name="l00159"></a>00159         {
<a name="l00160"></a>00160             StringBuilder objStringBuilder = <span class="keyword">new</span> StringBuilder();
<a name="l00161"></a>00161             objStringBuilder.AppendLine(<span class="stringliteral">&quot;&lt;html&gt;&lt;body&gt;&quot;</span>);
<a name="l00162"></a>00162 
<a name="l00163"></a>00163             <span class="keywordflow">if</span> (ds == null)
<a name="l00164"></a>00164             {
<a name="l00165"></a>00165                 objStringBuilder.AppendLine(<span class="stringliteral">&quot;Null dataset passed &quot;</span>);
<a name="l00166"></a>00166                 objStringBuilder.AppendLine(<span class="stringliteral">&quot;&lt;/html&gt;&lt;/body&gt;&quot;</span>);
<a name="l00167"></a>00167                 WriteIf(objStringBuilder.ToString());
<a name="l00168"></a>00168                 <span class="keywordflow">return</span> objStringBuilder.ToString();
<a name="l00169"></a>00169             }
<a name="l00170"></a>00170 
<a name="l00171"></a>00171             objStringBuilder.AppendLine(<span class="stringliteral">&quot;&lt;p&gt;&quot;</span> + msg + <span class="stringliteral">&quot; START &lt;/p&gt;&quot;</span>);
<a name="l00172"></a>00172             <span class="keywordflow">if</span> (ds != null)
<a name="l00173"></a>00173             {
<a name="l00174"></a>00174                 <span class="keywordflow">if</span> (ds.Tables == null)
<a name="l00175"></a>00175                 {
<a name="l00176"></a>00176                     objStringBuilder.AppendLine(<span class="stringliteral">&quot;ds.Tables == null &quot;</span>);
<a name="l00177"></a>00177                     <span class="keywordflow">return</span> objStringBuilder.ToString();
<a name="l00178"></a>00178                 }
<a name="l00179"></a>00179 
<a name="l00180"></a>00180 
<a name="l00181"></a>00181                 <span class="keywordflow">foreach</span> (System.Data.DataTable dt in ds.Tables)
<a name="l00182"></a>00182                 {
<a name="l00183"></a>00183 
<a name="l00184"></a>00184                     <span class="keywordflow">if</span> (dt == null)
<a name="l00185"></a>00185                     {
<a name="l00186"></a>00186                         objStringBuilder.AppendLine(<span class="stringliteral">&quot;ds.Tables == null &quot;</span>);
<a name="l00187"></a>00187                         <span class="keywordflow">continue</span>;
<a name="l00188"></a>00188                     }
<a name="l00189"></a>00189                     objStringBuilder.AppendLine(<span class="stringliteral">&quot;&lt;table&gt;&quot;</span>);
<a name="l00190"></a>00190 
<a name="l00191"></a>00191                     <span class="comment">//objStringBuilder.AppendLine(&quot;================= My TableName is  &quot; +</span>
<a name="l00192"></a>00192                     <span class="comment">//dt.TableName + &quot; ========================= START&quot;);</span>
<a name="l00193"></a>00193                     <span class="keywordtype">int</span> colNumberInRow = 0;
<a name="l00194"></a>00194                     objStringBuilder.Append(<span class="stringliteral">&quot;&lt;tr&gt;&lt;th&gt;row number&lt;/th&gt;&quot;</span>);
<a name="l00195"></a>00195                     <span class="keywordflow">foreach</span> (System.Data.DataColumn dc in dt.Columns)
<a name="l00196"></a>00196                     {
<a name="l00197"></a>00197                         <span class="keywordflow">if</span> (dc == null)
<a name="l00198"></a>00198                         {
<a name="l00199"></a>00199                             objStringBuilder.AppendLine(<span class="stringliteral">&quot;DataColumn is null &quot;</span>);
<a name="l00200"></a>00200                             <span class="keywordflow">continue</span>;
<a name="l00201"></a>00201                         }
<a name="l00202"></a>00202 
<a name="l00203"></a>00203 
<a name="l00204"></a>00204                         objStringBuilder.Append(<span class="stringliteral">&quot; &lt;th&gt; |&quot;</span> + colNumberInRow.ToString() + <span class="stringliteral">&quot; | &quot;</span>);
<a name="l00205"></a>00205                         objStringBuilder.Append(dc.ColumnName.ToString() + <span class="stringliteral">&quot; &lt;/th&gt; &quot;</span>);
<a name="l00206"></a>00206                         colNumberInRow++;
<a name="l00207"></a>00207                     } <span class="comment">//eof foreach (DataColumn dc in dt.Columns)</span>
<a name="l00208"></a>00208                     objStringBuilder.Append(<span class="stringliteral">&quot;&lt;/tr&gt;&quot;</span>);
<a name="l00209"></a>00209 
<a name="l00210"></a>00210                     <span class="keywordtype">int</span> rowNum = 0;
<a name="l00211"></a>00211                     <span class="keywordflow">foreach</span> (System.Data.DataRow dr in dt.Rows)
<a name="l00212"></a>00212                     {
<a name="l00213"></a>00213                         objStringBuilder.Append(<span class="stringliteral">&quot;&lt;tr&gt;&lt;td&gt; row - | &quot;</span> + rowNum.ToString() + <span class="stringliteral">&quot; | &lt;/td&gt;&quot;</span>);
<a name="l00214"></a>00214                         <span class="keywordtype">int</span> colNumber = 0;
<a name="l00215"></a>00215                         <span class="keywordflow">foreach</span> (System.Data.DataColumn dc in dt.Columns)
<a name="l00216"></a>00216                         {
<a name="l00217"></a>00217                             objStringBuilder.Append(<span class="stringliteral">&quot; &lt;td&gt; |&quot;</span> + colNumber + <span class="stringliteral">&quot;|&quot;</span>);
<a name="l00218"></a>00218                             objStringBuilder.Append(dr[dc].ToString() + <span class="stringliteral">&quot;  &lt;/td&gt;&quot;</span>);
<a name="l00219"></a>00219                             colNumber++;
<a name="l00220"></a>00220                         } <span class="comment">//eof foreach (DataColumn dc in dt.Columns)</span>
<a name="l00221"></a>00221                         rowNum++;
<a name="l00222"></a>00222                         objStringBuilder.AppendLine(<span class="stringliteral">&quot; &lt;/tr&gt;&quot;</span>);
<a name="l00223"></a>00223                     }   <span class="comment">//eof foreach (DataRow dr in dt.Rows)</span>
<a name="l00224"></a>00224 
<a name="l00225"></a>00225                     objStringBuilder.AppendLine(<span class="stringliteral">&quot;&lt;/table&gt;&quot;</span>);
<a name="l00226"></a>00226                     objStringBuilder.AppendLine(<span class="stringliteral">&quot;&lt;p&gt;&quot;</span> + msg + <span class="stringliteral">&quot; END &lt;/p&gt;&quot;</span>);
<a name="l00227"></a>00227                 }       <span class="comment">//eof foreach (DataTable dt in ds.Tables)</span>
<a name="l00228"></a>00228 
<a name="l00229"></a>00229             } <span class="comment">//eof if ds !=null </span>
<a name="l00230"></a>00230             <span class="keywordflow">else</span>
<a name="l00231"></a>00231             {
<a name="l00232"></a>00232 
<a name="l00233"></a>00233                 objStringBuilder.AppendLine(<span class="stringliteral">&quot;NULL DataSet object passed for debugging !!!&quot;</span>);
<a name="l00234"></a>00234             }
<a name="l00235"></a>00235             <span class="keywordflow">return</span> objStringBuilder.ToString();
<a name="l00236"></a>00236 
<a name="l00237"></a>00237         } <span class="comment">//eof method </span>
<a name="l00238"></a>00238 
<a name="l00239"></a>00239 
<a name="l00240"></a>00240 
<a name="l00241"></a>00241 
<a name="l00242"></a>00242 
<a name="l00243"></a>00243 
<a name="l00244"></a><a class="code" href="../../db/dac/classMinConsole_1_1Gaf_1_1Utils_1_1Dumper.html#a2eb39dffd03c2df70f46455e1c71cc56">00244</a>         <span class="keyword">public</span> <span class="keyword">static</span> <span class="keywordtype">string</span> DebugDataTable(<span class="keywordtype">string</span> msg, ref DataTable dt)
<a name="l00245"></a>00245         {
<a name="l00246"></a>00246             StringBuilder objStringBuilder = <span class="keyword">new</span> StringBuilder();
<a name="l00247"></a>00247             <span class="keywordflow">if</span> (dt == null)
<a name="l00248"></a>00248             {
<a name="l00249"></a>00249                 objStringBuilder.AppendLine(<span class="stringliteral">&quot;DebugDataTable I have been passed a null DataTable &quot;</span>);
<a name="l00250"></a>00250                 <span class="keywordflow">return</span> objStringBuilder.ToString(); ;
<a name="l00251"></a>00251             }
<a name="l00252"></a>00252             objStringBuilder.AppendLine(<span class="stringliteral">&quot;================= My TableName is  &quot;</span> +
<a name="l00253"></a>00253             dt.TableName + <span class="stringliteral">&quot; ========================= START&quot;</span>);
<a name="l00254"></a>00254             <span class="keywordtype">int</span> colNumberInRow = 0;
<a name="l00255"></a>00255             <span class="keywordflow">foreach</span> (System.Data.DataColumn dc in dt.Columns)
<a name="l00256"></a>00256             {
<a name="l00257"></a>00257                 objStringBuilder.Append(<span class="stringliteral">&quot; | &quot;</span>);
<a name="l00258"></a>00258                 objStringBuilder.Append(<span class="stringliteral">&quot; |&quot;</span> + colNumberInRow + <span class="stringliteral">&quot;| &quot;</span>);
<a name="l00259"></a>00259                 objStringBuilder.Append(dc.ColumnName + <span class="stringliteral">&quot; | &quot;</span>);
<a name="l00260"></a>00260                 colNumberInRow++;
<a name="l00261"></a>00261             } <span class="comment">//eof foreach (DataColumn dc in dt.Columns)</span>
<a name="l00262"></a>00262             <span class="keywordtype">int</span> rowNum = 0;
<a name="l00263"></a>00263             <span class="keywordflow">foreach</span> (System.Data.DataRow dr in dt.Rows)
<a name="l00264"></a>00264             {
<a name="l00265"></a>00265                 objStringBuilder.Append(<span class="stringliteral">&quot;\n row &quot;</span> + rowNum + <span class="stringliteral">&quot; --- &quot;</span>);
<a name="l00266"></a>00266                 <span class="keywordtype">int</span> colNumber = 0;
<a name="l00267"></a>00267                 <span class="keywordflow">foreach</span> (System.Data.DataColumn dc in dt.Columns)
<a name="l00268"></a>00268                 {
<a name="l00269"></a>00269                     objStringBuilder.Append(<span class="stringliteral">&quot; |&quot;</span> + colNumber + <span class="stringliteral">&quot;| &quot;</span>);
<a name="l00270"></a>00270                     objStringBuilder.Append(dr[dc].ToString() + <span class="stringliteral">&quot; &quot;</span>);
<a name="l00271"></a>00271                     colNumber++;
<a name="l00272"></a>00272                 } <span class="comment">//eof foreach (DataColumn dc in dt.Columns)</span>
<a name="l00273"></a>00273                 rowNum++;
<a name="l00274"></a>00274             }   <span class="comment">//eof foreach (DataRow dr in dt.Rows)</span>
<a name="l00275"></a>00275             objStringBuilder.Append(<span class="stringliteral">&quot; \n&quot;</span>);
<a name="l00276"></a>00276             objStringBuilder.AppendLine(<span class="stringliteral">&quot;================= Table &quot;</span> +
<a name="l00277"></a>00277             dt.TableName + <span class="stringliteral">&quot; ========================= END&quot;</span>);
<a name="l00278"></a>00278             objStringBuilder.AppendLine(<span class="stringliteral">&quot;===================================================&quot;</span> + msg + <span class="stringliteral">&quot; END &quot;</span>);
<a name="l00279"></a>00279             <span class="keywordflow">return</span> objStringBuilder.ToString();
<a name="l00280"></a>00280         } <span class="comment">//eof method</span>
<a name="l00281"></a>00281 
<a name="l00282"></a><a class="code" href="../../db/dac/classMinConsole_1_1Gaf_1_1Utils_1_1Dumper.html#a8241f5261feed18359b52ca4fb18476d">00282</a>         <span class="keyword">public</span> <span class="keyword">static</span> <span class="keywordtype">string</span> DebugHtmlDataTable(<span class="keywordtype">string</span> msg, ref DataTable dt)
<a name="l00283"></a>00283         {
<a name="l00284"></a>00284             StringBuilder objStringBuilder = <span class="keyword">new</span> StringBuilder();
<a name="l00285"></a>00285             <span class="keywordflow">if</span> (dt == null)
<a name="l00286"></a>00286             {
<a name="l00287"></a>00287                 objStringBuilder.AppendLine(<span class="stringliteral">&quot;DebugDataTable I have been passed a null DataTable &quot;</span>);
<a name="l00288"></a>00288                 <span class="keywordflow">return</span> objStringBuilder.ToString(); ;
<a name="l00289"></a>00289             }
<a name="l00290"></a>00290             objStringBuilder.AppendLine(<span class="stringliteral">&quot;&lt;p&gt; My TableName is  &quot;</span> +
<a name="l00291"></a>00291             dt.TableName + <span class="stringliteral">&quot;  START &lt;/p&gt;&quot;</span>);
<a name="l00292"></a>00292             <span class="keywordtype">int</span> colNumberInRow = 0;
<a name="l00293"></a>00293             <span class="keywordflow">foreach</span> (System.Data.DataColumn dc in dt.Columns)
<a name="l00294"></a>00294             {
<a name="l00295"></a>00295                 objStringBuilder.AppendLine(<span class="stringliteral">&quot; &lt;td&gt;&quot;</span>);
<a name="l00296"></a>00296                 objStringBuilder.AppendLine(<span class="stringliteral">&quot; |&quot;</span> + colNumberInRow.ToString() + <span class="stringliteral">&quot;| &quot;</span>);
<a name="l00297"></a>00297                 objStringBuilder.AppendLine(dc.ColumnName.ToString() + <span class="stringliteral">&quot; &lt;/td&gt; &quot;</span>);
<a name="l00298"></a>00298                 colNumberInRow++;
<a name="l00299"></a>00299             } <span class="comment">//eof foreach (DataColumn dc in dt.Columns)</span>
<a name="l00300"></a>00300             <span class="keywordtype">int</span> rowNum = 0;
<a name="l00301"></a>00301             <span class="keywordflow">foreach</span> (System.Data.DataRow dr in dt.Rows)
<a name="l00302"></a>00302             {
<a name="l00303"></a>00303                 objStringBuilder.AppendLine(<span class="stringliteral">&quot;&lt;tr&gt;&quot;</span> + rowNum + <span class="stringliteral">&quot; --- &quot;</span>);
<a name="l00304"></a>00304                 <span class="keywordtype">int</span> colNumber = 0;
<a name="l00305"></a>00305                 <span class="keywordflow">foreach</span> (System.Data.DataColumn dc in dt.Columns)
<a name="l00306"></a>00306                 {
<a name="l00307"></a>00307                     objStringBuilder.AppendLine(<span class="stringliteral">&quot; &lt;td&gt; |&quot;</span> + colNumber.ToString());
<a name="l00308"></a>00308                     objStringBuilder.AppendLine(dr[dc].ToString() + <span class="stringliteral">&quot;&lt;/td&gt; &quot;</span>);
<a name="l00309"></a>00309                     colNumber++;
<a name="l00310"></a>00310                 } <span class="comment">//eof foreach (DataColumn dc in dt.Columns)</span>
<a name="l00311"></a>00311                 rowNum++;
<a name="l00312"></a>00312             }   <span class="comment">//eof foreach (DataRow dr in dt.Rows)</span>
<a name="l00313"></a>00313 
<a name="l00314"></a>00314             objStringBuilder.AppendLine(<span class="stringliteral">&quot;&lt;/table&gt;&quot;</span>);
<a name="l00315"></a>00315             objStringBuilder.AppendLine(<span class="stringliteral">&quot;&lt;p&gt;Table &quot;</span> +
<a name="l00316"></a>00316             dt.TableName + <span class="stringliteral">&quot; END &lt;/p&gt;&quot;</span>);
<a name="l00317"></a>00317             objStringBuilder.AppendLine(<span class="stringliteral">&quot;&lt;p&gt;&quot;</span> + msg + <span class="stringliteral">&quot; END &lt;/p&gt;&quot;</span>);
<a name="l00318"></a>00318 
<a name="l00319"></a>00319             <span class="keywordflow">return</span> objStringBuilder.ToString();
<a name="l00320"></a>00320         } <span class="comment">//eof method</span>
<a name="l00321"></a>00321 
<a name="l00322"></a>00322 
<a name="l00328"></a><a class="code" href="../../db/dac/classMinConsole_1_1Gaf_1_1Utils_1_1Dumper.html#a1b336a1e5c1f16f4fcd76421df65120b">00328</a>         <span class="keyword">public</span> <span class="keyword">static</span> <span class="keywordtype">void</span> WriteIf(<span class="keywordtype">string</span> msg)
<a name="l00329"></a>00329         { 
<a name="l00330"></a>00330 
<a name="l00331"></a>00331         } <span class="comment">//eof method WriteIf</span>
<a name="l00332"></a>00332 
<a name="l00333"></a>00333 
<a name="l00334"></a>00334 
<a name="l00335"></a>00335 
<a name="l00336"></a>00336 
<a name="l00337"></a><a class="code" href="../../db/dac/classMinConsole_1_1Gaf_1_1Utils_1_1Dumper.html#a1a032236266f252a49b858899db57afb">00337</a>         <span class="keyword">public</span> <span class="keyword">static</span> <span class="keywordtype">void</span> IsNull(<span class="keywordtype">object</span> o)
<a name="l00338"></a>00338         {
<a name="l00339"></a>00339             <span class="keywordflow">if</span> (o == null)
<a name="l00340"></a>00340             {
<a name="l00341"></a>00341                 WriteIf(o.ToString() + <span class="stringliteral">&quot; IS null &quot;</span>);
<a name="l00342"></a>00342                 <span class="keywordflow">return</span>;
<a name="l00343"></a>00343             }
<a name="l00344"></a>00344             <span class="keywordflow">else</span>
<a name="l00345"></a>00345             {
<a name="l00346"></a>00346                 WriteIf(o.ToString() + <span class="stringliteral">&quot; IS NOT null&quot;</span>);
<a name="l00347"></a>00347             }
<a name="l00348"></a>00348         } <span class="comment">//eof IsNull</span>
<a name="l00349"></a>00349 
<a name="l00350"></a>00350 
<a name="l00351"></a>00351 
<a name="l00359"></a>00359         
<a name="l00360"></a>00360         
<a name="l00361"></a>00361         
<a name="l00362"></a>00362         
<a name="l00363"></a><a class="code" href="../../db/dac/classMinConsole_1_1Gaf_1_1Utils_1_1Dumper.html#ab470770723033dd7a7154e3bdbad63f4">00363</a>         <span class="keyword">public</span> <span class="keyword">static</span> <span class="keywordtype">string</span> DumpDsQoteColumns(
<a name="l00364"></a>00364             ref System.Data.DataSet ds, <span class="keywordtype">int</span>? tokenDelimiterAsciiNumber, <span class="keywordtype">int</span>? RowEndAsciiNumber )
<a name="l00365"></a>00365         {
<a name="l00366"></a>00366             <span class="keywordtype">string</span> strTokenDelimiter = Convert.ToString((<span class="keywordtype">char</span>)(tokenDelimiterAsciiNumber)) ?? <span class="stringliteral">&quot;\&quot;&quot;</span> ;
<a name="l00367"></a>00367             <span class="keywordtype">string</span> strRowEnd = Convert.ToString((<span class="keywordtype">char</span>)(RowEndAsciiNumber)) ?? <span class="stringliteral">&quot;\n&quot;</span> ;
<a name="l00368"></a>00368             <span class="keywordtype">string</span> strQuote = <span class="stringliteral">&quot;\&quot;&quot;</span>; 
<a name="l00369"></a>00369 
<a name="l00370"></a>00370             StringBuilder objStringBuilder = <span class="keyword">new</span> StringBuilder();
<a name="l00371"></a>00371 
<a name="l00372"></a>00372 
<a name="l00373"></a>00373 
<a name="l00374"></a>00374 
<a name="l00375"></a>00375             <span class="keywordflow">if</span> (ds == null)
<a name="l00376"></a>00376             {
<a name="l00377"></a>00377                 objStringBuilder.AppendLine(<span class="stringliteral">&quot;No result data in result set &quot;</span>);
<a name="l00378"></a>00378                 <span class="keywordflow">return</span> objStringBuilder.ToString();
<a name="l00379"></a>00379             }
<a name="l00380"></a>00380 
<a name="l00381"></a>00381             
<a name="l00382"></a>00382             <span class="keywordflow">if</span> (ds != null)
<a name="l00383"></a>00383             {
<a name="l00384"></a>00384                 <span class="keywordflow">if</span> (ds.Tables == null)
<a name="l00385"></a>00385                 {
<a name="l00386"></a>00386                     objStringBuilder.AppendLine(<span class="stringliteral">&quot;ds.Tables == null. No result data in result set &quot;</span>);
<a name="l00387"></a>00387                     <span class="keywordflow">return</span> objStringBuilder.ToString();
<a name="l00388"></a>00388                 }
<a name="l00389"></a>00389 
<a name="l00390"></a>00390                 
<a name="l00391"></a>00391                 <span class="keywordflow">foreach</span> (System.Data.DataTable dt in ds.Tables)
<a name="l00392"></a>00392                 {
<a name="l00393"></a>00393                     <span class="keywordflow">if</span> (dt == null)
<a name="l00394"></a>00394                     {
<a name="l00395"></a>00395                         objStringBuilder.AppendLine(<span class="stringliteral">&quot;ds.Tables == null. No result data in result set &quot;</span>);
<a name="l00396"></a>00396                         <span class="keywordflow">continue</span>;
<a name="l00397"></a>00397                     }
<a name="l00398"></a>00398 
<a name="l00399"></a>00399                     <span class="keywordtype">int</span> colNumberInRow = 0;
<a name="l00400"></a>00400 
<a name="l00401"></a>00401 <span class="preprocessor">                    #region ColumnTitles </span>
<a name="l00402"></a>00402 <span class="preprocessor"></span>                    <span class="comment">//foreach (System.Data.DataColumn dc in dt.Columns)</span>
<a name="l00403"></a>00403                     <span class="comment">//{</span>
<a name="l00404"></a>00404                     <span class="comment">//    if (dc == null)</span>
<a name="l00405"></a>00405                     <span class="comment">//    {</span>
<a name="l00406"></a>00406                     <span class="comment">//        objStringBuilder.AppendLine(&quot;dc.Columns== null &quot;);</span>
<a name="l00407"></a>00407                     <span class="comment">//        continue;</span>
<a name="l00408"></a>00408                     <span class="comment">//    }</span>
<a name="l00409"></a>00409 
<a name="l00410"></a>00410                     <span class="comment">//    objStringBuilder.Append(&quot; | &quot;);</span>
<a name="l00411"></a>00411                     <span class="comment">//    objStringBuilder.Append(&quot; |&quot; + colNumberInRow + &quot;| &quot;);</span>
<a name="l00412"></a>00412                     <span class="comment">//    objStringBuilder.Append(dc.ColumnName + &quot; | &quot;);</span>
<a name="l00413"></a>00413                     <span class="comment">//    colNumberInRow++;</span>
<a name="l00414"></a>00414                     <span class="comment">//} //eof foreach (DataColumn dc in dt.Columns)</span>
<a name="l00415"></a>00415 <span class="preprocessor">                    #endregion ColumnTitles </span>
<a name="l00416"></a>00416 <span class="preprocessor"></span>
<a name="l00417"></a>00417                     <span class="keywordtype">int</span> rowNum = 0;
<a name="l00418"></a>00418 
<a name="l00419"></a>00419                     <span class="keywordflow">foreach</span> (System.Data.DataRow dr in dt.Rows)
<a name="l00420"></a>00420                     {
<a name="l00421"></a>00421                         <span class="keywordtype">int</span> colNumber = 0;
<a name="l00422"></a>00422                         <span class="keywordflow">foreach</span> (System.Data.DataColumn dc in dt.Columns)
<a name="l00423"></a>00423                         {
<a name="l00424"></a>00424                             objStringBuilder.Append(strQuote + dr[dc].ToString() + strQuote + strTokenDelimiter);
<a name="l00425"></a>00425                             colNumber++;
<a name="l00426"></a>00426                         } <span class="comment">//eof foreach (DataColumn dc in dt.Columns)</span>
<a name="l00427"></a>00427                         objStringBuilder.Remove(objStringBuilder.Length - 1 , 1);   <span class="comment">//remove the last &quot; , &quot; </span>
<a name="l00428"></a>00428                         objStringBuilder.Append(strRowEnd);
<a name="l00429"></a>00429 
<a name="l00430"></a>00430                         rowNum++;
<a name="l00431"></a>00431                     }   <span class="comment">//eof foreach (DataRow dr in dt.Rows)</span>
<a name="l00432"></a>00432 
<a name="l00433"></a>00433                 }       <span class="comment">//eof foreach (DataTable dt in ds.Tables)</span>
<a name="l00434"></a>00434             } <span class="comment">//eof if ds !=null </span>
<a name="l00435"></a>00435             <span class="keywordflow">else</span>
<a name="l00436"></a>00436             {
<a name="l00437"></a>00437                 objStringBuilder.AppendLine(<span class="stringliteral">&quot;NULL DataSet object passed for debugging !!!&quot;</span>);
<a name="l00438"></a>00438             }
<a name="l00439"></a>00439             <span class="keywordflow">return</span> objStringBuilder.ToString();
<a name="l00440"></a>00440         } <span class="comment">//eof method </span>
<a name="l00441"></a>00441 
<a name="l00442"></a>00442 
<a name="l00443"></a>00443 
<a name="l00444"></a>00444     } <span class="comment">//eof class </span>
<a name="l00445"></a>00445 } <span class="comment">//eof namespace </span>
<a name="l00446"></a>00446 
</pre></div></div>
</div>
<hr class="footer"/><address class="footer"><small>Generated on Sat Jan 22 2011 22:24:47 for DataExtractor by&#160;
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="../../doxygen.png" alt="doxygen"/></a> 1.7.2 </small></address>
</body>
</html>
